package iwpl.project.servlet;

import iwpl.project.dao.DepartmentsDAO;
import iwpl.project.entities.Departments;
import iwpl.project.entitymanagerhelper.*;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Control_Department extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public Control_Department() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}
	
	public static void ExecuteControl(String Control, Departments Depart)
	{
		DepartmentsDAO dao = new DepartmentsDAO();
		
		if(Control == "Save")
		{
			EntityManagerHelper.beginTransaction();
			dao.save(Depart);
			EntityManagerHelper.commit();
		}
		
		if(Control == "Update")
		{
			EntityManagerHelper.beginTransaction();
			dao.update(Depart);
			EntityManagerHelper.commit();
		}
		
		if(Control == "Delete")
		{
			EntityManagerHelper.beginTransaction();
			dao.delete(Depart);
			EntityManagerHelper.commit();
		}
	}
	
	/**
	 * The doGet method of the servlet. <br>
	 * 
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request
	 *            the request send by the client to the server
	 * @param response
	 *            the response send by the server to the client
	 * @throws ServletException
	 *             if an error occurred
	 * @throws IOException
	 *             if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		/*response.setContentType("text/html");
		PrintWriter out = response.getWriter();
		out
				.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
		out.println("<HTML>");
		out.println("  <HEAD><TITLE>A Servlet</TITLE></HEAD>");
		out.println("  <BODY>");
		out.print("    This is ");
		out.print(this.getClass());
		out.println(", using the GET method");
		out.println("  </BODY>");
		out.println("</HTML>");
		out.flush();
		out.close();*/
		doProcess(request, response);
	}

	/**
	 * The doPost method of the servlet. <br>
	 * 
	 * This method is called when a form has its tag value method equals to
	 * post.
	 * 
	 * @param request
	 *            the request send by the client to the server
	 * @param response
	 *            the response send by the server to the client
	 * @throws ServletException
	 *             if an error occurred
	 * @throws IOException
	 *             if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		/*
		 * response.setContentType("text/html"); PrintWriter out =
		 * response.getWriter(); out.println(
		 * "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
		 * out.println("<HTML>");
		 * out.println("  <HEAD><TITLE>A Servlet</TITLE></HEAD>");
		 * out.println("  <BODY>"); out.print("    This is ");
		 * out.print(this.getClass()); out.println(", using the POST method");
		 * out.println("  </BODY>"); out.println("</HTML>"); out.flush();
		 * out.close();
		 */
		
		doProcess(request, response);
	}
	
	public void doProcess(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		
		Departments Depart = new Departments();
		
		String strDepartmentID = request.getParameter("TxtDepartmentID");
		String strDepartmentName = request.getParameter("TxtDepartmentName");
		String strAddress = request.getParameter("TxtAddress");
		String intTotalOfFloor = request.getParameter("TxtTotalOfFloor");
		String strPhone = request.getParameter("TxtPhone");
		
		String strStatusSave = request.getParameter("BtnSave");
		String strStatusUpdate = request.getParameter("BtnUpdate");
		String strStatusDelete = request.getParameter("delete");
		
		if(strStatusSave != null)
		{
			Depart.setDepartmentName(strDepartmentName);
			Depart.setAddress(strAddress);
			Depart.setTotalOfFloor(Integer.parseInt(intTotalOfFloor));
			Depart.setPhone(strPhone);
			
			ExecuteControl("Save", Depart);
			// After run command, return main page
			response.sendRedirect("/DepartmentManage/Manage_Departments.jsp");
		}
		
		if(strStatusDelete != null)
		{	
			Depart.setId(Integer.parseInt(strStatusDelete));
			ExecuteControl("Delete", Depart);
			// After run command, return main page
			response.sendRedirect("/DepartmentManage/Manage_Departments.jsp");
		}
		
		if (strStatusUpdate != null)
		{	
			Depart.setId(Integer.parseInt(strDepartmentID));
			Depart.setDepartmentName(strDepartmentName);
			Depart.setAddress(strAddress);
			Depart.setTotalOfFloor(Integer.parseInt(intTotalOfFloor));
			Depart.setPhone(strPhone);
			
			ExecuteControl("Update", Depart);
			// After run command, return main page
			response.sendRedirect("/DepartmentManage/Manage_Departments.jsp");
		}
		
		
		
	}
	
	/**
	 * Initialization of the servlet. <br>
	 * 
	 * @throws ServletException
	 *             if an error occurs
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}
